package com.woniu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.woniu.entity.WishConfig;
import com.woniu.vo.WishConfigVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @Description:
 * @Author: woniu
 * @date: 2023/12/22 9:51
 */
@Mapper
public interface WishConfigMapper extends BaseMapper<WishConfig> {

    @Select("SELECT wc.id AS wish_id,wc.`wish` AS wish_text FROM wish_config AS wc ORDER BY RAND() LIMIT 1")
    WishConfigVO findRandomVO();
}
